SELECT * FROM q_user;
SELECT * FROM q_emp;

DROP TABLE q_emp;

CREATE TABLE q_user(
  username VARCHAR2(9) ,
  password VARCHAR2(6)
);

CREATE TABLE q_emp(
  id VARCHAR2(5) PRIMARY KEY ,
  name VARCHAR2(8) ,
  salary VARCHAR2(8),
  age VARCHAR2(3)
);

CREATE SEQUENCE q_emp_sel START WITH 1000;


INSERT INTO q_user (username, password) VALUES ('Sediment','123123');
INSERT INTO q_user (username, password) VALUES ('Adrien','123123');

INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'Daniel','14000','15');
INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'James','12000','15');
INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'Excel','15000','15');


INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'Taylor','14000','15');
INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'Swift','12000','15');
INSERT INTO q_emp(id, name, salary, age) VALUES (q_emp_sel.nextval,'Sediment','15000','15');

COMMIT ;